semicolon (;), 33, 179–180
sequences
of clauses, 117
collation sequences, 278–280
of evaluation, 59–61, 80
ServerProperty() function, 279
SET IDENTITY_INSERT statement, 177
SET statement, 186, 215–216
setting up
access rights, 291–292
full-text searching
full-text catalogs, 163–166
full-text indexes, 164–166
full-text search support, 162–163
Sin() function, 94
sines, returning, 94
single quotes (’), 53, 169, 220
single values, checking against, 51–52
sorting combined query results, 158–159
sorting data
in ascending order, 46–47
case sensitivity and, 46
in descending order, 44–46
dictionary sort order, 46
grouping versus sorting, 114–116
by multiple columns, 43–44
by single column, 41–43
Soundex() function, 85–86
sp_columns stored procedure, 27–28
sp_databases stored procedure, 26
sp_fulltext_database stored procedure, 162–163
sp_helplogins stored procedure, 28, 289
SP_HELPTRIGGER stored procedure, 250
sp_helpuser stored procedure, 28
sp_rename stored procedure, 201